﻿<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="MYSMRM.Model" namespace="MYSMRM.Model">

  <class name="QSSurvey" table="QS_SURVEY">
    <cache usage="read-write"/>
    <id name="ID" type="int">
      <column name="I_ID" index="PK_QS_SURVEY"/>
      <generator class="identity" />
    </id>

    <property name="QuestionID" type="int">
      <column name="I_QUESTION_ID" not-null="true"/>
    </property>

    <property name="OptionID" type="int">
      <column name="I_OPTION_ID" not-null="true"/>
    </property>

    <property name="Option" type="String">
      <column name="S_OPTION" not-null="true"/>
    </property>

    <property name="Comment" type="String">
      <column name="S_COMMENT" not-null="true"/>
    </property>

    <property name="Submitter" type="String">
      <column name="S_SUBMITTER" not-null="true"/>
    </property>

    <property name="SubmitDate" type="DateTime">
      <column name="D_SUBMIT_DATE" not-null="true"/>
    </property>

  </class>

</hibernate-mapping>